inherited FRelatorio_Retorno: TFRelatorio_Retorno
  Left = 226
  Top = 188
  Height = 500
  Caption = 'Relat'#243'rio Ocorr'#234'ncia Retorno'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 16
  inherited Panel2: TPanel
    Caption = 'RELAT'#211'RIO ARQUIVO RETORNO'
  end
  inherited GroupBox1: TGroupBox
    object Label3: TLabel
      Left = 18
      Top = 23
      Width = 43
      Height = 16
      Caption = 'N'#186' Lote'
    end
    object Edit1: TEdit
      Left = 16
      Top = 39
      Width = 76
      Height = 22
      TabOrder = 0
    end
  end
  inherited GroupBox2: TGroupBox
    object GBOrdernar: TGroupBox
      Left = 10
      Top = 63
      Width = 188
      Height = 75
      Caption = '  Ordernar por  '
      TabOrder = 5
      object RBVencimento: TRadioButton
        Left = 10
        Top = 17
        Width = 139
        Height = 21
        Caption = 'Vencimento'
        Checked = True
        TabOrder = 0
        TabStop = True
      end
      object RBFornecedor: TRadioButton
        Left = 10
        Top = 33
        Width = 154
        Height = 21
        Caption = 'C'#243'digo de Retorno'
        TabOrder = 1
      end
      object RBCod_Titulo: TRadioButton
        Left = 10
        Top = 49
        Width = 154
        Height = 21
        Caption = 'C'#243'digo do T'#237'tulo'
        TabOrder = 2
      end
    end
  end
  inherited RLReport: TRLReport
    Left = -40
    Top = 309
    DataSource = DSPesquisa
    object RLBand2: TRLBand
      Left = 38
      Top = 120
      Width = 718
      Height = 25
      BandType = btColumnHeader
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = False
      Borders.DrawRight = False
      Borders.DrawBottom = False
      object RLLabel1: TRLLabel
        Left = 7
        Top = 5
        Width = 53
        Height = 16
        Caption = 'N'#186' T'#237'tulo'
      end
      object RLLabel2: TRLLabel
        Left = 64
        Top = 5
        Width = 104
        Height = 16
        Caption = 'Data Vencimento'
      end
      object RLLabel3: TRLLabel
        Left = 190
        Top = 5
        Width = 34
        Height = 16
        Caption = 'Valor'
      end
      object RLLabel5: TRLLabel
        Left = 345
        Top = 5
        Width = 194
        Height = 16
        Caption = 'Mensagem de Retorno do Banco'
      end
      object RLLabel4: TRLLabel
        Left = 229
        Top = 5
        Width = 49
        Height = 16
        Caption = 'N'#186' Doc.'
      end
      object RLLabel6: TRLLabel
        Left = 313
        Top = 5
        Width = 31
        Height = 16
        Caption = 'Cod.'
      end
      object RLLabel7: TRLLabel
        Left = 655
        Top = 6
        Width = 52
        Height = 16
        Caption = 'Registro'
      end
    end
    object RLBand3: TRLBand
      Left = 38
      Top = 145
      Width = 718
      Height = 134
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = True
      Borders.DrawRight = False
      Borders.DrawBottom = False
      BeforePrint = RLBand3BeforePrint
      object RLDBText2: TRLDBText
        Left = 8
        Top = 2
        Width = 51
        Height = 16
        AutoSize = False
        DataField = 'PAGITENS_COD_CP'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText3: TRLDBText
        Left = 64
        Top = 2
        Width = 104
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_CP_DATA_VENCIMENTO'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText4: TRLDBText
        Left = 172
        Top = 3
        Width = 52
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        DataField = 'PAGITENS_VALOR_TITULO'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText6: TRLDBText
        Left = 343
        Top = 3
        Width = 307
        Height = 16
        AutoSize = False
        DataField = 'RET1'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText5: TRLDBText
        Left = 228
        Top = 3
        Width = 81
        Height = 16
        AutoSize = False
        DataField = 'PAGITENS_CP_DOCUMENTO'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText7: TRLDBText
        Left = 343
        Top = 24
        Width = 308
        Height = 16
        AutoSize = False
        DataField = 'RET2'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText8: TRLDBText
        Left = 343
        Top = 45
        Width = 308
        Height = 16
        AutoSize = False
        DataField = 'RET3'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText9: TRLDBText
        Left = 343
        Top = 65
        Width = 308
        Height = 16
        AutoSize = False
        DataField = 'RET4'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText10: TRLDBText
        Left = 344
        Top = 85
        Width = 307
        Height = 16
        AutoSize = False
        DataField = 'RET5'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText11: TRLDBText
        Left = 313
        Top = 3
        Width = 28
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_COD_RETORNO1'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText12: TRLDBText
        Left = 311
        Top = 24
        Width = 30
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_COD_RETORNO2'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText13: TRLDBText
        Left = 311
        Top = 45
        Width = 30
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_COD_RETORNO3'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText14: TRLDBText
        Left = 312
        Top = 64
        Width = 30
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_COD_RETORNO4'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLDBText15: TRLDBText
        Left = 312
        Top = 85
        Width = 30
        Height = 16
        Alignment = taCenter
        AutoSize = False
        DataField = 'PAGITENS_COD_RETORNO5'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel8: TRLLabel
        Left = 653
        Top = 4
        Width = 58
        Height = 15
        Caption = 'transa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel9: TRLLabel
        Left = 654
        Top = 25
        Width = 58
        Height = 15
        Caption = 'transa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel10: TRLLabel
        Left = 654
        Top = 46
        Width = 58
        Height = 15
        Caption = 'transa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel11: TRLLabel
        Left = 654
        Top = 65
        Width = 58
        Height = 15
        Caption = 'transa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel12: TRLLabel
        Left = 655
        Top = 85
        Width = 58
        Height = 15
        Caption = 'transa'#231#227'o'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
    end
    object RLBand4: TRLBand
      Left = 38
      Top = 279
      Width = 718
      Height = 66
      BandType = btSummary
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = True
      Borders.DrawRight = False
      Borders.DrawBottom = False
      object RLLabel13: TRLLabel
        Left = 129
        Top = 5
        Width = 97
        Height = 15
        Alignment = taRightJustify
        Caption = 'Data Vencimento'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel14: TRLLabel
        Left = 129
        Top = 21
        Width = 97
        Height = 15
        Alignment = taRightJustify
        Caption = 'Data Vencimento'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel15: TRLLabel
        Left = 129
        Top = 37
        Width = 97
        Height = 15
        Alignment = taRightJustify
        Caption = 'Data Vencimento'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel16: TRLLabel
        Left = 6
        Top = 5
        Width = 74
        Height = 15
        Alignment = taRightJustify
        Caption = 'Valor T'#237'tulos:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel17: TRLLabel
        Left = 6
        Top = 21
        Width = 93
        Height = 15
        Alignment = taRightJustify
        Caption = 'Valor Agendado:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel18: TRLLabel
        Left = 6
        Top = 37
        Width = 59
        Height = 15
        Alignment = taRightJustify
        Caption = 'Diferen'#231'a:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
    end
  end
  inherited QPesquisa: TQuery
    Active = True
    SQL.Strings = (
      ' select '
      ' pagfor_lote_cabecalho.*,'
      ' pagfor_lote_itens.pagitens_cod_cp,'
      ' pagfor_lote_itens.pagitens_cod_fornecedor,'
      ' pagfor_lote_itens.pagitens_codigo,'
      ' pagfor_lote_itens.pagitens_cp_data_vencimento,'
      ' pagfor_lote_itens.pagitens_cp_documento,'
      ' pagfor_lote_itens.pagitens_retorno_ok,'
      ' pagfor_lote_itens.pagitens_valor_titulo,'
      ' pagfor_lote_itens.pagitens_cod_retorno1,'
      ' ret1.pfo_mensagem as ret1,'
      ' pagfor_lote_itens.pagitens_cod_retorno2,'
      ' ret2.pfo_mensagem as ret2,'
      ' pagfor_lote_itens.pagitens_cod_retorno3,'
      ' ret3.pfo_mensagem as ret3,'
      ' pagfor_lote_itens.pagitens_cod_retorno4,'
      ' ret4.pfo_mensagem as ret4,'
      ' pagfor_lote_itens.pagitens_cod_retorno5,'
      ' ret5.pfo_mensagem as ret5,'
      ' ret5.pfo_mensagem as ret5,'
      ' ret1.pfo_registro as reg1,'
      ' ret2.pfo_registro as reg2,'
      ' ret3.pfo_registro as reg3,'
      ' ret4.pfo_registro as reg4,'
      ' ret5.pfo_registro as reg5'
      ' from pagfor_lote_cabecalho'
      
        ' inner join pagfor_lote_itens on (pagfor_lote_cabecalho.pag_codi' +
        'go = pagfor_lote_itens.pagitens_pag_codigo)'
      
        ' left join  pagfor_ocorrencia  ret1 on (pagfor_lote_itens.pagite' +
        'ns_cod_retorno1 = ret1.pfo_codigo_ocorrencia)'
      
        ' left join  pagfor_ocorrencia  ret2 on (pagfor_lote_itens.pagite' +
        'ns_cod_retorno2 = ret2.pfo_codigo_ocorrencia)'
      
        ' left join  pagfor_ocorrencia  ret3 on (pagfor_lote_itens.pagite' +
        'ns_cod_retorno3 = ret3.pfo_codigo_ocorrencia)'
      
        ' left join  pagfor_ocorrencia  ret4 on (pagfor_lote_itens.pagite' +
        'ns_cod_retorno4 = ret4.pfo_codigo_ocorrencia)'
      
        ' left join  pagfor_ocorrencia  ret5 on (pagfor_lote_itens.pagite' +
        'ns_cod_retorno5 = ret5.pfo_codigo_ocorrencia)')
    Left = 224
    Top = 425
  end
  inherited DSPesquisa: TDataSource
    Left = 128
    Top = 406
  end
end
